﻿<List Title="HR" Url="Lists/HR" BaseType="0" Type="100" Name="HR"
      DisableAttachments="TRUE" FolderCreation="FALSE" VersioningEnabled="FALSE" EnableContentTypes="TRUE"
      xmlns="http://schemas.microsoft.com/sharepoint/">
  <MetaData>
    <ContentTypes>
      <ContentType ID="0x01003b7743e4960c4618865f01f122aeb500"
               Name="ConsolidationTool_HR"
               Group="ConsolidationTool"
               Description="Custom Content Type">
        <FieldRefs>
          <FieldRef Name="Title" ID="{990F92EE-B4F7-4B71-8B82-6AB376057244}"/>
          <FieldRef Name="LinkTitle" ID="{990F92EE-B4F7-4B71-8B82-6AB376057245}"/>
          <FieldRef Name="CoCd" ID="{990F92EE-B4F7-4B71-8B82-6AB376057246}"/>
          <FieldRef Name="CoFullName" ID="{990F92EE-B4F7-4B71-8B82-6AB376057247}"/>
          <FieldRef Name="CoName" ID="{990F92EE-B4F7-4B71-8B82-6AB376057248}"/>
          <FieldRef Name="Year" ID="{990F92EE-B4F7-4B71-8B82-6AB376057249}"/>
          <FieldRef Name="Month" ID="{990F92EE-B4F7-4B71-8B82-6AB376057250}"/>
          <FieldRef Name="Region" ID="{990F92EE-B4F7-4B71-8B82-6AB376057251}"/>
          <FieldRef Name="SubRegion" ID="{990F92EE-B4F7-4B71-8B82-6AB376057252}"/>
          <FieldRef Name="Currency" ID="{2BAEE8FD-A2DB-4AC9-9FCD-D0DE228CEAAB}"/><FieldRef Name="Tonnage" ID="{2302F567-2F3B-4E07-BB9D-81474E4CC2E0}"/><FieldRef Name="Control" ID="{adecb3aa-6032-4654-a256-74678c586442}"/>

          <FieldRef Name="HR01010100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057253}"/>
          <FieldRef Name="HR01010101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057254}"/>
          <FieldRef Name="HR01010102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057255}"/>
          <FieldRef Name="HR01010103" ID="{990F92EE-B4F7-4B71-8B82-6AB376057256}"/>
          <FieldRef Name="HR01010104" ID="{990F92EE-B4F7-4B71-8B82-6AB376057257}"/>
          <FieldRef Name="HR01010105" ID="{990F92EE-B4F7-4B71-8B82-6AB376057258}"/>
          <FieldRef Name="HR01010106" ID="{990F92EE-B4F7-4B71-8B82-6AB376057259}"/>
          <FieldRef Name="HR01010200" ID="{990F92EE-B4F7-4B71-8B82-6AB376057260}"/>
          <FieldRef Name="HR01010301" ID="{990F92EE-B4F7-4B71-8B82-6AB376057261}"/>
          <FieldRef Name="HR01010302" ID="{990F92EE-B4F7-4B71-8B82-6AB376057262}"/>
          <FieldRef Name="HR01020100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057263}"/>
          <FieldRef Name="HR01020101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057264}"/>
          <FieldRef Name="HR01020102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057265}"/>
          <FieldRef Name="HR01020103" ID="{990F92EE-B4F7-4B71-8B82-6AB376057266}"/>
          <FieldRef Name="HR01020104" ID="{990F92EE-B4F7-4B71-8B82-6AB376057267}"/>
          <FieldRef Name="HR01020105" ID="{990F92EE-B4F7-4B71-8B82-6AB376057268}"/>
          <FieldRef Name="HR01020106" ID="{990F92EE-B4F7-4B71-8B82-6AB376057269}"/>
          <FieldRef Name="HR01020200" ID="{990F92EE-B4F7-4B71-8B82-6AB376057270}"/>
          <FieldRef Name="HR01030101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057271}"/>
          <FieldRef Name="HR01030102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057272}"/>
          <FieldRef Name="HR01030100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057273}"/>
          <FieldRef Name="HR01040101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057274}"/>
          <FieldRef Name="HR01040102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057275}"/>
          <FieldRef Name="HR01040100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057276}"/>
          <FieldRef Name="HR01050100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057277}"/>
          <FieldRef Name="HR01060100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057278}"/>
          <FieldRef Name="HR01060101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057279}"/>
          <FieldRef Name="HR01060102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057280}"/>
          <FieldRef Name="HR01070100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057281}"/>
          <FieldRef Name="HR01070101" ID="{990F92EE-B4F7-4B71-8B82-6AB376057282}"/>
          <FieldRef Name="HR01070102" ID="{990F92EE-B4F7-4B71-8B82-6AB376057283}"/>

          <FieldRef Name="HR01060100_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057284}"/>
          <FieldRef Name="HR01060101_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057285}"/>
          <FieldRef Name="HR01060102_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057286}"/>
          <FieldRef Name="HR01070100_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057287}"/>
          <FieldRef Name="HR01070101_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057288}"/>
          <FieldRef Name="HR01070102_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057289}"/>

          <FieldRef Name="HR01020300" ID="{990F92EE-B4F7-4B71-8B82-6AB376057290}"/>
          <FieldRef Name="HR01090100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057291}"/>
          <FieldRef Name="HR01090100_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057292}"/>
          <FieldRef Name="HR01080100" ID="{990F92EE-B4F7-4B71-8B82-6AB376057293}"/>
          <FieldRef Name="HR01080100_YTD" ID="{990F92EE-B4F7-4B71-8B82-6AB376057294}"/>

        </FieldRefs>
        <XmlDocuments>
          <XmlDocument NamespaceURI="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
            <FormUrls xmlns="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
              <New>Lists/HR/HRNewForm.aspx</New>
              <Edit>Lists/HR/HREditForm.aspx</Edit>
              <Display>Lists/HR/HRDisplayForm.aspx</Display>
            </FormUrls>
          </XmlDocument>
        </XmlDocuments>
      </ContentType>
    </ContentTypes>

    <Fields>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057244}" Type="Text"  DisplayName="NO."  Name="Title"   StaticName="Title" Required="TRUE"   Indexed="TRUE" EnforceUniqueValues="true" />
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057245}" Type="Computed"  DisplayName="NO." Name="LinkTitle"  StaticName="LinkTitle" ReadOnly="TRUE"></Field>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057246}" Type="Text"    DisplayName="Company Code" Name="CoCd"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057247}" Type="Text"    DisplayName="Company Full Name" Name="CoFullName"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057248}" Type="Text"  DisplayName="Company Name"  Name="CoName"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057249}" Type="Integer"  DisplayName="Year"  Name="Year"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057250}" Type="Integer"  DisplayName="Month"  Name="Month"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057251}" Type="Text"  DisplayName="Region"  Name="Region"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057252}" Type="Text"  DisplayName="Sub Region"  Name="SubRegion"/>
      <Field ID="{2BAEE8FD-A2DB-4AC9-9FCD-D0DE228CEAAB}" Group="ConsolidationField" Type="Text"  DisplayName="Currency"  Name="Currency"/><Field ID="{2302F567-2F3B-4E07-BB9D-81474E4CC2E0}" Group="ConsolidationField" Type="Text"  DisplayName="Tonnage"  Name="Tonnage"/>
      <Field Name="Control" FromBaseType="FALSE" Type="Note" DisplayName="Control" Required="FALSE" EnforceUniqueValues="FALSE" Indexed="FALSE" NumLines="6" RichText="FALSE" RichTextMode="Compatible" IsolateStyles="FALSE" Sortable="FALSE" IMEMode="inactive" ID="{adecb3aa-6032-4654-a256-74678c586442}" Version="2" StaticName="Control" SourceID="{661A2117-3576-4AF4-B243-B7673CF4C933}" ColName="ntext2" RowOrdinal="0" RestrictedMode="TRUE" AppendOnly="FALSE" />

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057253}" Type ="Integer" DisplayName ="Roquette Headcount-month end" Name="HR01010100"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057254}" Type ="Integer" DisplayName ="Operations" Name="HR01010101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057255}" Type ="Integer" DisplayName ="Sales" Name="HR01010102"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057256}" Type ="Integer" DisplayName ="Logistics" Name="HR01010103"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057257}" Type ="Integer" DisplayName ="GMU" Name="HR01010104"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057258}" Type ="Integer" DisplayName ="Administration/Corporate" Name="HR01010105"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057259}" Type ="Integer" DisplayName ="R&amp;D" Name="HR01010106"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057260}" Type ="Integer" DisplayName ="Temp Headcount-month end" Name="HR01010200"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057261}" Type ="Integer" DisplayName ="Direct" Name="HR01010301"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057262}" Type ="Integer" DisplayName ="Indirect" Name="HR01010302"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057263}" Type ="Number" DisplayName ="Roquette Full Time Equivalent-month" Name="HR01020100"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057264}" Type ="Number" DisplayName ="Operations" Name="HR01020101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057265}" Type ="Number" DisplayName ="Sales" Name="HR01020102"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057266}" Type ="Number" DisplayName ="Logistics" Name="HR01020103"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057267}" Type ="Number" DisplayName ="GMU" Name="HR01020104"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057268}" Type ="Number" DisplayName ="Administration/Corporate" Name="HR01020105"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057269}" Type ="Number" DisplayName ="R&amp;D" Name="HR01020106"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057270}" Type ="Number" DisplayName ="Temp Full Time Equivalent-month" Name="HR01020200"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057290}" Type ="Number" DisplayName ="Working Days" Name="HR01020300"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057271}" Type ="Integer" DisplayName ="Roquette-Working hours-Excl. OT" Name="HR01030101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057272}" Type ="Integer" DisplayName ="Temp-Working hours-Excl. OT" Name="HR01030102"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057273}" Type ="Integer" DisplayName ="Total-working hour-Excl. OT" Name="HR01030100"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057274}" Type ="Integer" DisplayName ="Roquette-Overtime hours" Name="HR01040101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057275}" Type ="Integer" DisplayName ="emp-Overtime hours" Name="HR01040102"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057276}" Type ="Integer" DisplayName ="Total -Overtime hours" Name="HR01040100"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057277}" Type ="Integer" DisplayName ="Total working hours" Name="HR01050100"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057278}" Type ="Integer" DisplayName ="Headcount-Turnover" Name="HR01060100"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057279}" Type ="Integer" DisplayName ="voluntary" Name="HR01060101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057280}" Type ="Integer" DisplayName ="Involuntary" Name="HR01060102"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057281}" Type ="Number" DisplayName ="Turnover Ratio" Name="HR01070100"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057282}" Type ="Number" DisplayName ="Voluntary ratio" Name="HR01070101"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057283}" Type ="Number" DisplayName ="Involuntary ratio" Name="HR01070102"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057284}" Type ="Integer" DisplayName ="Headcount-Turnover-YTD" Name="HR01060100_YTD"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057285}" Type ="Integer" DisplayName ="Voluntary-YTD" Name="HR01060101_YTD"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057286}" Type ="Integer" DisplayName ="Involuntary-YTD" Name="HR01060102_YTD"/>

      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057287}" Type ="Number" DisplayName ="Turnover Ratio_YTD" Name="HR01070100_YTD"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057288}" Type ="Number" DisplayName ="Voluntary ratio_YTD" Name="HR01070101_YTD"/>
      <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057289}" Type ="Number" DisplayName ="Involuntary ratio_YTD" Name="HR01070102_YTD"/>

        <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057291}" Type ="Number" DisplayName ="Number of promotion" Name="HR01090100"/>
        <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057292}" Type ="Number" DisplayName ="Number of promotion_YTD" Name="HR01090100_YTD"/>
        
        <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057293}" Type ="Number" DisplayName ="Training hours" Name="HR01080100"/>
        <Field ID="{990F92EE-B4F7-4B71-8B82-6AB376057294}" Type ="Number" DisplayName ="Training hours_YTD" Name="HR01080100_YTD"/>
        
    </Fields>
    <Forms>
      <Form Type="DisplayForm" Url="DispForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="EditForm" Url="EditForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="NewForm" Url="NewForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
    </Forms>

    <Views>
      <View DisplayName="All Items" DefaultView="TRUE" BaseViewID="1" Type="HTML"
            WebPartZoneID="Main" WebPartOrder="1" Url="AllItems.aspx" SetupPath="pages\viewpage.aspx" >
        <XslLink>main.xsl</XslLink>
        <ViewFields>
          <FieldRef Name="Title"/>
          <FieldRef Name="CoCd"/>
          <FieldRef Name="CoFullName"/>
          <FieldRef Name="CoName"/>
          <FieldRef Name="Year"/>
          <FieldRef Name="Month"/>
          <FieldRef Name="Region"/>
          <FieldRef Name="SubRegion"/>
        </ViewFields>
        <RowLimit Paged="TRUE">30</RowLimit>
      </View>
    </Views>
  </MetaData>
</List>
